﻿CREATE VIEW dbo.vwRepriceLines
AS
SELECT     R.Id, R.DocId, NP.GoodsId, OP.Id AS OldPartyId, OP.RetailPrice AS OldPrice, OP.BarCode AS OldBarCode, NL.Qntty, NP.Id AS NewPartyId, 
                      NP.RetailPrice AS NewRetailPrice, NP.BarCode AS NewBarCode, R.RepriceWriteoffReasonId, 
                      CO.RepriceWriteoffReason.Name AS RepriceWriteoffReasonName, R.RepriceWriteoffReasonText, R.QualityLossMark, R.Note, R.MD, R.MW, 
                      OL.Id AS OLId, NL.Id AS NLId
FROM         CD.Parties AS OP INNER JOIN
                      CA.GoodsDocLines AS OL ON OP.Id = OL.PartyId INNER JOIN
                      CA.GoodsDocLines AS NL ON OL.DocId = NL.DocId AND OL.Id = NL.ReturnLineId INNER JOIN
                      CD.Parties AS NP ON NL.PartyId = NP.Id AND NL.DocId = NP.DocId INNER JOIN
                      CD.RepriceWriteoffLines AS R ON NL.Id = R.GoodsDocLineId INNER JOIN
                      CO.RepriceWriteoffReason ON R.RepriceWriteoffReasonId = CO.RepriceWriteoffReason.Id

GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[45] 4[26] 2[13] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "OP"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 256
               Right = 190
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "OL"
            Begin Extent = 
               Top = 5
               Left = 243
               Bottom = 256
               Right = 395
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "NL"
            Begin Extent = 
               Top = 9
               Left = 464
               Bottom = 251
               Right = 616
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "NP"
            Begin Extent = 
               Top = 8
               Left = 658
               Bottom = 249
               Right = 810
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "R"
            Begin Extent = 
               Top = 259
               Left = 231
               Bottom = 421
               Right = 455
            End
            DisplayFlags = 280
            TopColumn = 4
         End
         Begin Table = "RepriceWriteoffReason (CO)"
            Begin Extent = 
               Top = 257
               Left = 635
               Bottom = 372
               Right = 787
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 15
         Width = 284
         Width = 1500
         Width = 1500
         Width', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'vwRepriceLines';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane2', @value = N' = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3420
         Alias = 1950
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'vwRepriceLines';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 2, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'vwRepriceLines';

